USE [aspnetdb]
GO

-- =============================================
-- Author     :		Lohith Ram D V
-- Create date:         08/mar/2011
-- =============================================

create procedure sp_GetUserRole(
	@par_userid int) 
AS
BEGIN
	SELECT [User1].[role_id]
	FROM [User1]
	WHERE [User1].[user1_id]=@par_userid
END
